﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderHeader_GetModel]
(
	@Id  int
)

AS

SELECT TOP 1
	ROH.[Id],
	ROH.[ReturnOrderNumber],
	ROH.[ReturnOrderStatusId],
	ROH.[WangWangId],
	ROH.[CustomerName],
	ROH.[CustomerCellphone],
	ROH.[CustomerAddress],
	ROH.[CreatedBy],
	ROH.[UpdatedBy],
	ROH.[CreatedOn],
	ROH.[UpdatedOn]
	FROM dbo.[OPM_ReturnOrderHeader] ROH 
	WHERE ROH.[Id] = @Id